How to: Import Excel data as text.
Solution:
Copy Excel data using the 'Copy' command and 'Paste Special...' into a Word document as unformatted text.
1) Copy the Excel data.
a) Select the data to be imported into the Word document.
b) Select the 'Edit' menu and select 'Copy'.
2) Switch to Word.
3) Open the desired Word document.
4) Position the insertion point where the data is to be placed.
5) Paste the Excel data into the document.
a) Select the 'Edit' menu and select 'Paste Special...'. (The Paste Special dialog box appears.)
b) Select the 'Paste' radio button.
c) Select 'Unformatted Text' from the 'As' list box.
d) Click 'OK'.
NOTE 1: To paste formatted text, select 'Formatted Text (RTF)' from the list box.
NOTE 2: By choosing the 'Paste' option, a copy of the data from Excel is placed into Word. The data from Excel is NOT copied as a worksheet; instead, a text representation of the data is copied into the Word document. The data can be edited manually in Word as text. Any changes made to the worksheet in Excel will NOT be reflected in the Word document.
